-- SQL Loader Control and Data File created by TOAD
-- Variable length, terminated enclosed data formatting
-- 
-- The format for executing this file with SQL Loader is:
-- SQLLDR control=<filename> Be sure to substitute your
-- version of SQL LOADER and the filename for this file.
LOAD DATA
INFILE *
BADFILE './tteam.BAD'
DISCARDFILE './tteam.DSC'
APPEND INTO TABLE TOTE.TTEAM
Fields terminated by ";" Optionally enclosed by '"'
(
  TEAMID NULLIF (TEAMID="NULL"),
  TEAMNAME,
  teamurl,
  lob_file FILLER char,
    TEAMLOGO LOBFILE(lob_file) TERMINATED BY EOF,
  GROUPID,
  GROUPNO NULLIF (GROUPNO="NULL"),
  GROUPPOSITION NULLIF (GROUPPOSITION="NULL"),
  TOTALPOSITION NULLIF (TOTALPOSITION="NULL"),
  STATUS_ NULLIF (STATUS_="NULL")
)
BEGINDATA
1;South Africa;http://www.fifa.com/worldcup/teams/index.html;rsa.gif;Group A;1;NULL;NULL;210
2;Mexico;http://www.fifa.com/worldcup/teams/index.html;mex.gif;Group A;2;NULL;NULL;210
3;Uruguay;http://www.fifa.com/worldcup/teams/index.html;uru.gif;Group A;3;NULL;NULL;210
4;France;http://www.fifa.com/worldcup/teams/index.html;fra.gif;Group A;4;NULL;NULL;210
5;Argentina;http://www.fifa.com/worldcup/teams/index.html;arg.gif;Group B;1;NULL;NULL;210
6;Nigeria;http://www.fifa.com/worldcup/teams/index.html;nga.gif;Group B;2;NULL;NULL;210
7;Korea Republic;http://www.fifa.com/worldcup/teams/index.html;kor.gif;Group B;3;NULL;NULL;210
8;Greece;http://www.fifa.com/worldcup/teams/index.html;gre.gif;Group B;4;NULL;NULL;210
9;England;http://www.fifa.com/worldcup/teams/index.html;eng.gif;Group C;1;NULL;NULL;210
10;USA;http://www.fifa.com/worldcup/teams/index.html;usa.gif;Group C;2;NULL;NULL;210
11;Algeria;http://www.fifa.com/worldcup/teams/index.html;alg.gif;Group C;3;NULL;NULL;210
12;Slovenia;http://www.fifa.com/worldcup/teams/index.html;svn.gif;Group C;4;NULL;NULL;210
13;Germany;http://www.fifa.com/worldcup/teams/index.html;ger.gif;Group D;1;NULL;NULL;210
14;Australia;http://www.fifa.com/worldcup/teams/index.html;aus.gif;Group D;2;NULL;NULL;210
15;Serbia;http://www.fifa.com/worldcup/teams/index.html;srb.gif;Group D;3;NULL;NULL;210
16;Ghana;http://www.fifa.com/worldcup/teams/index.html;gha.gif;Group D;4;NULL;NULL;210
17;Netherlands;http://www.fifa.com/worldcup/teams/index.html;ned.gif;Group E;1;NULL;NULL;210
18;Denmark;http://www.fifa.com/worldcup/teams/index.html;den.gif;Group E;2;NULL;NULL;210
19;Japan;http://www.fifa.com/worldcup/teams/index.html;jpn.gif;Group E;3;NULL;NULL;210
20;Cameroon;http://www.fifa.com/worldcup/teams/index.html;cmr.gif;Group E;4;NULL;NULL;210
21;Italy;http://www.fifa.com/worldcup/teams/index.html;ita.gif;Group F;1;NULL;NULL;210
22;Paraguay;http://www.fifa.com/worldcup/teams/index.html;par.gif;Group F;2;NULL;NULL;210
23;New Zealand;http://www.fifa.com/worldcup/teams/index.html;nzl.gif;Group F;3;NULL;NULL;210
24;Slovakia;http://www.fifa.com/worldcup/teams/index.html;svk.gif;Group F;4;NULL;NULL;210
25;Brazil;http://www.fifa.com/worldcup/teams/index.html;bra.gif;Group G;1;NULL;NULL;210
26;Korea DPR;http://www.fifa.com/worldcup/teams/index.html;prk.gif;Group G;2;NULL;NULL;210
27;Cote d'Ivoire;http://www.fifa.com/worldcup/teams/index.html;civ.gif;Group G;3;NULL;NULL;210
28;Portugal;http://www.fifa.com/worldcup/teams/index.html;por.gif;Group G;4;NULL;NULL;210
29;Spain;http://www.fifa.com/worldcup/teams/index.html;esp.gif;Group H;1;NULL;NULL;210
30;Switzerland;http://www.fifa.com/worldcup/teams/index.html;sui.gif;Group H;2;NULL;NULL;210
31;Honduras;http://www.fifa.com/worldcup/teams/index.html;hon.gif;Group H;3;NULL;NULL;210
32;Chile;http://www.fifa.com/worldcup/teams/index.html;chi.gif;Group H;4;NULL;NULL;210